from sqlalchemy import Column, Integer, String, TIMESTAMP, ForeignKey, SmallInteger
from base import Base  # 导入共享的 Base

class RedBookVIP(Base):
    __tablename__ = 'red_book_vips'
    id = Column(Integer, primary_key=True, autoincrement=True, comment="主键ID")
    uuid = Column(String(36), ForeignKey('red_book_users.uuid'), nullable=False, comment="关联用户的UUID")
    level_id = Column(Integer, comment="level_id")
    status = Column(SmallInteger, ForeignKey('red_book_users.status'), nullable=False, comment="状态")
    start_time = Column(TIMESTAMP, nullable=False, comment="VIP开始时间")
    end_time = Column(TIMESTAMP, nullable=False, comment="VIP结束时间")
    created_at = Column(TIMESTAMP, comment='创建时间')
    updated_at = Column(TIMESTAMP, comment='更新时间')
    deleted_at = Column(TIMESTAMP, comment='删除时间')
    amount_id = Column(Integer, comment="金额ID")
